create table employee 
(
	EmpId int not null,
	EmpName varchar(5),
	Department varchar(15),
	Salary int not null
)

select * from employee;

Select Department,count(*) as EmployeeCount from employee group by Department

	Select 
		Department
		,count(*) Reccount 
		,max(salary) as MaxSalary
		,min(salary) as MinSalary
		,sum(salary) as SumOfSalary
		,avg(salary) as AvgOfSalary
	from 
		employee group by Department